Cannot get correct calculated time/date to appear due to wrong use.
Cause:
Date and time data must use the 'DateDiff' function for performing calculations.
Solution:
In Query Design view, use the 'DateDiff' function to add or subtract two date or time fields in an expression.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query. (The query is highlighted.)
4) Click 'Design'. (The query appears in Query Design view.)
5) Click in the 'Field' box for the desired expression.
6) Build the expression using the following command:
<Expression>:DateDiff(n,date1,date2)
EXAMPLE 1: Total Time:DateDiff(n,[TimeStarted],[TimeEnded])
(where <Total Time> is the stored data, 'n' is to display the result in minutes, <[TimeStarted]> is the first field name, and <[TimeEnded]> is the second field name).
EXAMPLE 2: Number of Days:DateDiff(y,Now(),[EndDate])
(where <Number of Days> is the stored data, 'y' is to display the Day of Year, 'Now()' is the current date, and [EndDate] is the field name).
7) Select the 'File' menu and select 'Save' to save changes to the query.
